Job Description :
Position: AB Initio Developer
Location: Minneapolis, MN – 100% Remote
Duration: Long Term Contract
The engagement requires strong self-starter to fulfill the role of a Senior Team Player, that will become an important piece of our Data Management Practice especially ETL Design and development.
The primary responsibilities are:
Provide technical consultation and support in the development of ETL applications and programs for data warehousing class of systems
Analyze business requirements, design and write technical specifications to design or redesign ETL solutions
Define and develop source-to-target data mapping specifications
Develop original and/or complex code or provides coding guidance to less experienced staff
Lead and/or perform functional unit testing and data analysis efforts
Verify ETL program logic by overseeing and consulting about the preparation of test data, testing and debugging of programs
Design the product implementation strategy and participate in overall systems integration testing
Lead the migration of ETL application’s components to production environment and document production deployment process
Develop new documentation to depict ETL data flow and participate in the development of technical procedures and new ETL design patterns associated with AB Initio stack of tools
Provide guidance and direction to less experienced staff in resolution of escalated issues and/or complex production, application or system problems.
Work in On-site/Off-shore Team, Guide other ETL Developers
Working effectively with Non co-located Team members
Required Qualifications:
10+ years of Data Warehouse / ETL applications design methodologies and experience including the ability to produce robust code, follow best practices and coding standards, design/implement common ETL strategies (CDC, SCD, etc, and create reusable/maintainable automated solutions
7+ years of Architecting ETL Applications using Ab Initio Echo System/Product Suite (Core Ab Initio Graphs, EME, Metadata-Hub, Data Quality Environment, Express>It/ACE/BRE, Conduct>It, Control Center)
5+ years of hands-on Lead ETL Designer/Developer expertise building ETL Applications
5+ experience Loading and Integrating data in complex and high volume environment using GDE Graphs, EME, Express>It
5+ Experience working in On-site/Off-shore model
3+ years of SQL experience with both Teradata 13.0 and SQL Server 2008/2012
3+ years of UNIX Shell (Ksh / Csh)
1+ years of Autosys or similar enterprise scheduling tools
1+ years of Anthill Pro or similar deployment automation tools
Preferred Qualifications:
Excellent verbal, written, and interpersonal communication skills
Experience with ETL tools migration projects
Ability to work and coordinate dependencies with multi-functional and cross-functional technical teams • Ability to provide end-to-end system design for all components and modules of ETL application
Expert knowledge of relational and multi-dimensional databases
Perl or Shell or UNIX scripting experience for automation of routine processes
SAS programming experience
Strong strategic and conceptual thinking skills
Consumer lending data experience • Leadership experience including; coaching, training, and mentoring • Capacity of designing solutions around Ab Initio, with advanced skills in high performance and parallelism in Ab Initio
Experience in Ab Initio Design and the application specific configurations