Data Engineer

ETL Senior DeveloperAn ETL senior developer is responsible for developing data flow architectures within various integration patterns for loading analytical structures or integrating and migrating applications. In doing so, he/she leverages industry-strength data movement technologies such as InfoSphere DataStage, Informatica PowerCenter or others.Job Duties:Configure and customize the chosen ETL tool for client installations.Optimally leverage the ETL tool components for developing efficient solutions for data management, conversion, migration and integration.Develop overall design and determine division of labor across various architectural components.Deploy and customize Standard Architecture components.Mentor client personnel. Train junior staff on the Integration Methodologies and related supplemental solutions.Support development of task plans including schedule and effort estimation, under the guidance of an ETL architect.Minimum Experience:Minimum 5 years of experienceAdvanced ETL experience using either Informatica or Data StageStrong individual contributor in complex Data Warehousing and Business Intelligence project implementations; leadership experience a plusProven experience in working directly with business customersStrong SQL skills including complex query building and query performance tuningData analysis skills - ability to dig in and understand complex models and business processesUDB, SQL Server, Oracle, My SQL, Netezza or Teradata database experienceStrong UNIX shell scripting skills (primarily in COBOL, Perl)Strong understanding of Data warehousing design concepts/skillsData profiling experienceDefining and implementing data integration architectureStrong ETL performance tuning skills. The ability to quickly and efficiently analyze and resolve performance issues within variety of operational environments.Demonstrated ability to analyze data concerning production volumes, batch schedules, and i/o statistics.Proven problem-solving / problem resolution abilities.Microsoft Office (Outlook, Excel, Word, PowerPoint, Access)ETL experience using either Informatica or Data Stage or an equivalent technologySQLUNIX shell scriptingPreferred Requirements:Dimensional data modeling skillsFamiliar with Agile Development MethodologyStarTeam Software Configuration Management ToolSAS ExperienceBusiness Objects (Webi, Xcelsius, Crystal Reports) or an equivalent technologyMS Analysis ServicesGeneral Host KnowledgeControl-m scheduling toolProficiency in scripting (in order of preference): Korn, PerlRequired Skills: Python/PySpark Hadoop SQL Big Data LinuxBasic Qualification: The candidate will need to complete a live screening on video. This screening will include a coding challenge. Additional Skills: The candidate will need to complete a live screening on video. This screening will include a coding challenge.