Responsible for Designing, Coding, Testing, Implementing, Maintaining, and Supporting ETL applications that are delivered within scope, with high quality, on time, and within budget
Work closely with Business partners & Technology team members to understand business requirements
Perform analysis and design of quality technical solutions that comply with the organization's architectural standards
Provide technical guidance to the development team through the full software life cycle
Develop solutions in a highly demanding environment and provide hands-on guidance to other team members
Implement an Informatica-based ETL solution fulfilling stringent performance requirements
Conduct impact assessments and determine the size of effort based on requirements
Provide support to Project Manager in developing full SDLC project plans to implement ETL solutions
Identify, recommend, and implement ETL process and architecture improvements
Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture
Resolve difficult design and develop issues and performance tuning of ETL code
Understand and follow-up through change management procedures to implement project deliverables
Coordinate with support groups such as DBA, Unix, Informatica admins to get issues resolved in a quick turnaround time

Bachelor’s degree in Computer Science, Engineering, or related field; or equivalent work experience
4-7 years of relevant experience
Expert with data warehousing standards, strategies, and tools
Expert with SDLC processes
Experience in Informatica Power exchange for Mainframe, Salesforce, and other new age data sources
Experience in Informatica Webservices, XML, Java Transformations etc.
Strong knowledge of relational databases preferably ORACLE and SQL Server
Good knowledge of UNIX/LINUX shell scripting
Strong SQL background
Strong problem-solving, multi-tasking, and organizational skills
Good written and verbal communication skills
Experience working with US or other international customers
Proven ability to successfully translate client/business needs into software designs
Individual contributor with strong communication skills
Proven ability to build relationships and collaborate with teams across the organization
Flexibility in timings for installs and secondary production support.

Senior ETL Developer

Key skills