*Hi All,* *Please check and let me know*
*Kindly mail me at nik...@apetan.com <nik...@apetan.com>* *Title: Lead Database Developer * *Location: DC * *Duration –Long Term Contract* *Interview Process: Skype/Telephone & In-person Interview mandatory* *GC-EAD, GC, USC will be an added advantage* *Detail Job Description: * The Lead Database Developer, will be responsible for supporting and providing quality of delivery for data extraction, transformation and load needs through the development of new or enhancement of existing routines. This position is also responsible for the onboarding and training of new ETL Developers, providing feedback regarding strengths and/or weaknesses so we can ensure they are working on the right projects. *Duties and Responsibilities: * • Work with BI Architecture and Innovations group to craft solution for data integration and business layer. • Integrate new data sources for EMM solution – structured/semi-structured and unstructured data from various sources in support of the electronic marketing management tools and other related systems. • Work with Business Intelligence Operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data ,establish and follow proper incident management procedures. • Develop and maintain thorough business knowledge of source data in Enterprise Data Warehouse supporting Enterprise Marketing Management (EMM) solution. • Perform source target mapping in support of report and warehouse technical designs. • Implement business-driven requirements using Informatica. • Work closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs. • Conduct ETL performance tuning, troubleshooting, support and capacity estimation. • Develop, adhere to, and be a proponent for Data Warehouse development standards, including ETL standards and best practices. • Maintain thorough understanding of business processes and ETL processes, and identify efficiencies and needed controls to fine-tune ETL operation. • Support validation and testing of developed workflows and business intelligence system integration testing. • Provide documentation for all developed ETL processes, including process flow and data mapping. • Develop audit reporting and quality improvement processes to ensure accurate and consistent delivery of data. • Work with BI Operations – Tier I and Tier II teams to rollout data controls and define incident management process for data issues. • Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data. *Minimum Qualifications: * • Bachelor’s degree or equivalent combination of education and experience preferred. • 6+ years experience of data architecture with one or more of the following: Teradata, Oracle, SQL Server. • 4+ years experience with Informatica ETL development required. • 4+ years Unix shell scripting. *Requirements and General Skills: * • Excellent SQL skills for complex data analysis and data quality assurance. • Exceptional data modeling skills. • Strong analytical and problem solving capabilities. • Hands-on experience with table spaces, indexes, partitions, and query performance tuning. • Demonstrated ability to work independently and with large teams. • Demonstrated ability to communicate and gather requirements from the Business. • Ability to partner with enterprise architects, business architects, analysts and development teams to deliver rapid iterations of complex solutions. • Excellent oral and written communication skills. • Ability to manage multiple assignments simultaneously and follow up on unfinished business. • Ability to work independently and in a team environment. • Ability to pay attention to details and be organized. • Ability to project professionalism over the phone and in person. • Commitment to “internal client” and customer service principles. • Ability to handle multiple tasks in a fast-paced environment. • Willingness to take initiative and to follow through on projects. • Spelling, grammar, proofreading and editing skills. • Creative writing ability. • Must have legal right to work in the U.S. *Technical Skills: * • Teradata, Oracle, MS SQL Server. • Experience using ETL tools (ex. Informatica, Golden Gate, etc.). • Advanced SQL query techniques and automating import/export tasks using Teradata utilities. • Mastery of stored procedures, SQL coding, queries, index and database IO performance tuning. • Comprehensive understanding of Data Warehouse design principles. • Ability to proactively identify, troubleshoot and resolve complex data integrity issues. • Teradata Certification preferred. • Subscription-based industry experience preferred. Thanks Nikhil Prasad nik...@apetan.com 201-620-9700*130 Apetan Consulting LLC -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at https://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.