ETL Developer (Raleigh, NC)

Syntelli Solutions, Inc - Charlotte, NC (30+ days ago)


An ETL Developer, due to the nature of our teams and engagements, must also be a capable leader. Often working with an architect, they must bring technical leadership and expertise to the project. Specifically, experience with Application Software, Maintenance, Testing, Optimization, Engineering, and Process Improvement projects. They should exhibit a clear and thorough understanding of business processes and workflows and be comfortable working in both waterfall and agile methodologies. Candidates must have advanced knowledge of SQL Server, SSIS Catalog, SSIS, T-SQL, and some data modeling experience.

Key Responsibilities

Design, build, and deploy effective SSIS packages
Implement stored procedures and effectively query a database
Translate requirements from the business and analyst into technical code
Identify and test for bugs and bottlenecks in the ETL solutions
Ensure the best possible performance and quality in the packages
Provide support and address issues in the packages
Work with architects to design optimal ETL pipeline

Outstanding analytical and problem-solving skills
Strong grasp of the technical aspects of business intelligence
Strong communication skills, able to regularly deal with both business and technical stakeholders
Proven track record of writing advanced SQL, including query tuning
Experience identifying data quality
Database design experience a plus
Experience designing and building a complete ETL/SSIS process moving and transforming data for ODS, Staging, and Data Warehousing
Knowledge of C#/VB.NET a plus
Ability to utilize ad-hoc techniques to perform on-the-fly data analysis
Proficiency in deploying and debugging a production SSIS environment
Sample Technical Profile

ETL Tools Ab-Initio V2.15, Ab Initio V 3.0.x, Ab initio 3.1.x, Datastage Designer v9.1, Informatica
Data Base Oracle, Microsoft SQL Server, IBM Netezza, IBM DB2, Teradata v14
Operating System UNIX, AIX, DOS, Windows 7, Windows XP
Languages SQL, PL/SQL, Unix shell scripting
Scheduling Tools Tivoli workload scheduler, AutoSys and Control-M
Version Control Tool EME, CA7 Harvest
Domain Knowledge Banking, Insurance and Logistics
Defect Tracking Tool HP-Mercury Quality Center
Application Tools MS Word, MS Excel, WinScp, Notepad ++, EditPlus, TextPad
Data Modeling Star Schema and Snowflake schema, Erwin tool.

BS in Mathematics, Economics, Computer Science, Information Management, Statistics, or similar
Masters in related field preferred