ETL Developer Support Job Vacancy in TalentAll Recruitment Services Chennai, Tamil Nadu – Updated today
Are you looking for a New Job or Looking for better opportunities?
We got a New Job Opening for
Full Details :
Company Name : TalentAll Recruitment Services
Location : Chennai, Tamil Nadu
Position :
Job Description : Competencies/Skills: Individual Contributor Competencies
Education: B.Tech Computers/MCA
Experience: 6 to 8 years in development projects with BI/ DWH background
Skills:
5+ years of hands-on and good experience in ETL tools – Informatica/SyncSort
Excellent Communication and analytic skills
Good Understanding of Data Warehousing and Data Modelling and be able to interpret logical, physical data models, conceptual models, and ER Diagrams.
Knowledge of SAFe Agile Methodology
Perform hands-on design and development activities for Extract Transform and Load (ETL) tasks using Guardian approved tools like Informatica and SSIS and adept at performing impact analysis for ETL changes.
Perform hands-on development activities using Guardian approved tools like Syncsort components (DMX tasks and jobs, integrating with scheduler), HIVE, HAWQ, Spark SQL, AWS-EMR and perform Unit testing for all deliverables
Perform hands-on UNIX, PL/SQL, HQL development and perform Unit testing for all deliverables
Create and maintain Technical documentation for work deliverables including but not limited to Functional specification, Unit Test Plans, Deployment and Migration Documents, Mapping Document, Data Flow Document, Runbooks and Release notes
Experience with advanced PL/SQL – Procedures, Triggers, Constraints, Cursors, Functions
Experience with ETL and query performance optimization, technical analysis, and solution design
Coordinate and interact with the On-site / Off-shore team to clarify on requirements / issues if any
Perform all applicable SDLC activities for the work items assigned including requirement analysis, impact analysis and effort estimations.
Perform initial analysis of tasks, perform effort estimations based on Guardian standards, assign and monitor work queues.
Provide Review, Testing support and production deployment and post-production (warranty) support for work deliverables
Ensure adherence to Guardian Security, Compliance and Development Standards for work deliverables.
Co-ordination with the Guardian SME’s and participate in knowledge transition sessions
Establish, maintain, and enforce ETL design principles, techniques, standards, and best practices
Drive the technical design of ETL reference architecture to ensure high data quality, data integration performance and error recovery/handling.
Review and assess existing ETL applications, to support new features, performance improvements, upgrades, and provide ongoing support.
Resolve any Application defects or Job abends
Work closely with other teams – DBA’s, Network, Storage, Scheduling and User Admin to triage issues and resolve job abends
Work on creating steady state deliverables and provide clarifications required for timely Production incident resolution and carrying out
On Call Level 2 Production support activities for supported applications
Responsible for proof-of-concept of new approaches and ideas, technology evaluation, maintain the As Is data architecture, develop To Be and transition architecture.
Self-motivated and ability to work on his/her individual capacity
Ability to identify automation opportunities and implement automation
Technology:
Informatica, SSIS, Syncsort, UNIX, PL/SQL, Querying using HIVE, PRESTO, Spark, understanding of Data Warehousing and Data Modelling, Oracle, SQL Server, DB2, UDB, HADOOP, AWS EMR, Python
Informatica Certified preferred
This post is listed Under Technology
Disclaimer : Hugeshout works to publish latest job info only and is no where responsible for any errors. Users must Research on their own before joining any company