ETL Developer (Raleigh, NC)

Syntelli Solutions, Inc - Charlotte, NC

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

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. Education
  • BS in Mathematics, Economics, Computer Science, Information Management, Statistics, or similar
  • Masters in related field preferred